create or replace procedure PRC_MB_PUSHMSG(PRM_MSG IN VARCHAR2) is
begin
  INSERT INTO TMP_MSG VALUES(  'PUSH' , PRM_MSG ,SYSDATE,substr( prm_msg , 5 , 10 ) );
end PRC_MB_PUSHMSG;
/
